/*
 Navicat Premium Data Transfer

 Source Server         : crm-project
 Source Server Type    : MySQL
 Source Server Version : 80401 (8.4.1)
 Source Host           : localhost:3306
 Source Schema         : crm-database

 Target Server Type    : MySQL
 Target Server Version : 80401 (8.4.1)
 File Encoding         : 65001

 Date: 15/10/2024 20:11:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `content` text COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL DEFAULT '1',
  `createdByAccount` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedBy` int NOT NULL DEFAULT '1',
  `updatedByAccount` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `updatedTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `isDeleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_fca3cb9ba4963678f564f22e7a` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` (`id`, `title`, `description`, `content`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (1, '学习算法真辛苦', '算法描述', '学习算法和数据结构', 4, 'sun@wukong.com', '2024-10-10 20:25:50.826745', 1, 'niunai@niunai.com', '2024-10-15 13:37:14.000000', 1);
INSERT INTO `article` (`id`, `title`, `description`, `content`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (2, '卖苹果的小女孩', '文章描述文章描述文章描述文章描述', '文章内容文章内容文章内容', 4, 'sun@wukong.com', '2024-10-11 10:00:44.113814', 4, 'sun@wukong.com', '2024-10-11 15:26:03.000000', 0);
INSERT INTO `article` (`id`, `title`, `description`, `content`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (3, 'react第一章', 'react第一章要先学JS', 'react第一章内容太多了', 4, 'sun@wukong.com', '2024-10-11 13:28:32.535189', 4, 'sun@wukong.com', '2024-10-11 14:53:19.000000', 1);
INSERT INTO `article` (`id`, `title`, `description`, `content`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (4, 'vue大法好', 'vue学的好，前端坑不少', '我就爱学vue', 4, 'sun@wukong.com', '2024-10-11 15:02:29.683169', 4, 'sun@wukong.com', '2024-10-11 15:02:29.683169', 0);
INSERT INTO `article` (`id`, `title`, `description`, `content`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (5, '《钢铁是怎样炼成的》阅读笔记', '钢铁是怎样炼成的', '钢铁是怎样炼成的钢铁是怎样炼成的钢铁是怎样炼成的钢铁是怎样炼成的', 7, 'zhu@bajie.com', '2024-10-12 13:28:00.171709', 7, 'zhu@bajie.com', '2024-10-12 13:28:00.171709', 0);
INSERT INTO `article` (`id`, `title`, `description`, `content`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (7, '月光下的湖面', '在宁静的夜晚，月光洒在湖面上，波光粼粼，宁静而祥和。', '# 月光下的湖面\n\n> 在宁静的夜晚，月光洒在湖面上，波光粼粼，宁静而祥和。\n\n**月光**轻轻地洒在湖面上，银色的光辉与湖水交织成一幅动人的画面。夜风轻拂，带来了远处森林的清新气息，也带来了湖水的微凉。湖面像一面巨大的镜子，倒映着夜空中的繁星和那一轮皎洁的明月。星星点点的光斑随着微风轻轻摇曳，仿佛是夜空与湖水之间的私语。\n\n在这样的夜晚，时间似乎变得缓慢，所有的烦恼和喧嚣都被这片宁静所吞噬。偶尔，`一条小鱼`跃出水面，打破*了湖面的宁静，却又迅速回归平静，只留下一圈圈扩散的波纹。这些波纹像是时间的涟漪*，提醒着我们即使在最平静的表面下，生活也充满了动态的变化。\n\n**湖边的柳树随风轻轻摆动，它们的枝条似乎在抚摸着湖面，与湖水进行着无声的交流。这样的场景让人心生感慨，自然界的和谐与平衡在这一刻展现得淋漓尽致。月光下的湖面不仅是一处美丽的风景，更是一种心灵的慰藉，它让我们在繁忙的生活中找到了一片宁静的港湾。**\n\n~~在这样的夜晚，我们的心灵得到了净化，我们的思想得到了升华。月光下的湖面，是自然赋予我们的一份宁静的礼物，让我们在其中找到了内心的平和与安宁。~~', 1, 'niunai@niunai.com', '2024-10-15 16:07:29.893733', 1, 'niunai@niunai.com', '2024-10-15 16:19:16.000000', 0);
COMMIT;

-- ----------------------------
-- Table structure for article_column_related
-- ----------------------------
DROP TABLE IF EXISTS `article_column_related`;
CREATE TABLE `article_column_related` (
  `id` int NOT NULL AUTO_INCREMENT,
  `articleId` int NOT NULL,
  `columnId` int NOT NULL,
  `isDeleted` int NOT NULL DEFAULT '0',
  `articleTitle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `columnTitle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_0907390589e3fa3686c2f073ba4` (`articleId`),
  KEY `FK_b38849a9674cac4a0a833711535` (`columnId`),
  CONSTRAINT `FK_0907390589e3fa3686c2f073ba4` FOREIGN KEY (`articleId`) REFERENCES `article` (`id`),
  CONSTRAINT `FK_b38849a9674cac4a0a833711535` FOREIGN KEY (`columnId`) REFERENCES `special_column` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of article_column_related
-- ----------------------------
BEGIN;
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (1, 1, 1, 1, '学习算法真辛苦', '香港电影专辑');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (2, 1, 3, 1, '学习算法真辛苦', '天下武功合集');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (3, 1, 6, 1, '学习算法真辛苦', '专栏标题6666');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (4, 2, 2, 1, '卖苹果的小女孩', 'react从出生学到入土');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (5, 2, 4, 1, '卖苹果的小女孩', '专栏标题444');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (6, 2, 5, 1, '卖苹果的小女孩', '魔兽世界');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (7, 3, 4, 1, 'react第一章', '专栏标题444');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (8, 3, 5, 1, 'react第一章', '魔兽世界');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (9, 3, 6, 1, 'react第一章', '专栏标题6666');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (10, 4, 1, 0, 'vue大法好', '香港电影专辑');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (11, 4, 2, 1, 'vue大法好', 'react从出生学到入土');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (12, 4, 3, 0, 'vue大法好', '天下武功合集');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (13, 2, 1, 0, '卖苹果的小女孩', '香港电影专辑');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (14, 2, 3, 0, '卖苹果的小女孩', '天下武功合集');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (15, 3, 1, 0, 'react第一章', '香港电影专辑');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (16, 5, 5, 0, '《钢铁是怎样炼成的》阅读笔记', '魔兽世界');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (17, 5, 2, 0, '《钢铁是怎样炼成的》阅读笔记', 'react从出生学到入土');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (18, 7, 5, 0, '月光下的湖面', '魔兽世界');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (19, 7, 7, 0, '月光下的湖面', '矿泉水');
INSERT INTO `article_column_related` (`id`, `articleId`, `columnId`, `isDeleted`, `articleTitle`, `columnTitle`) VALUES (20, 7, 3, 0, '月光下的湖面', '天下武功合集');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `weight` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`id`, `type`, `name`, `weight`) VALUES (1, 'systemAdmin', '系统管理员', 0);
INSERT INTO `role` (`id`, `type`, `name`, `weight`) VALUES (2, 'admin', '管理员', 1);
INSERT INTO `role` (`id`, `type`, `name`, `weight`) VALUES (3, 'user', '用户', 2);
INSERT INTO `role` (`id`, `type`, `name`, `weight`) VALUES (4, 'viewer', '访客', 3);
COMMIT;

-- ----------------------------
-- Table structure for special_column
-- ----------------------------
DROP TABLE IF EXISTS `special_column`;
CREATE TABLE `special_column` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(200) COLLATE utf8mb4_general_ci NOT NULL,
  `createdBy` int NOT NULL DEFAULT '1',
  `createdByAccount` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedBy` int NOT NULL DEFAULT '1',
  `updatedByAccount` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `updatedTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `isDeleted` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_8f3c3e5cf00c02b95c36ef74c1` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of special_column
-- ----------------------------
BEGIN;
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (1, '香港电影专辑', '我爱周星驰电影', 1, 'niunai@niunai.com', '2024-10-10 14:55:18.990848', 1, 'niunai@niunai.com', '2024-10-15 14:35:52.000000', 0);
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (2, 'react从出生学到入土', '一入react深似海', 1, 'niunai@niunai.com', '2024-10-10 15:43:30.612686', 1, 'niunai@niunai.com', '2024-10-15 14:34:50.000000', 0);
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (3, '天下武功合集', '天下风云出我辈，一入江湖岁月催。皇图霸业谈笑中,不胜人生一场醉。', 1, 'niunai@niunai.com', '2024-10-10 15:45:03.263098', 1, 'niunai@niunai.com', '2024-10-15 14:33:02.000000', 0);
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (4, '专栏标题444', '专栏描述444专栏描述444', 1, 'niunai@niunai.com', '2024-10-10 15:50:47.822139', 4, 'sun@wukong.com', '2024-10-11 14:21:35.000000', 1);
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (5, '魔兽世界', '一遇wow误终身', 1, 'niunai@niunai.com', '2024-10-10 15:52:09.508791', 1, 'niunai@niunai.com', '2024-10-15 14:36:22.000000', 0);
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (6, '专栏标题6666', '专栏描述6666专栏描述6666', 8, 'sha@seng.com', '2024-10-10 16:05:39.182336', 1, 'niunai@niunai.com', '2024-10-15 14:27:33.000000', 1);
INSERT INTO `special_column` (`id`, `title`, `description`, `createdBy`, `createdByAccount`, `createdTime`, `updatedBy`, `updatedByAccount`, `updatedTime`, `isDeleted`) VALUES (7, '矿泉水', '娃哈哈、农夫你更喜欢谁？', 1, 'niunai@niunai.com', '2024-10-15 14:37:48.149330', 1, 'niunai@niunai.com', '2024-10-15 14:37:48.149330', 0);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `roleId` int NOT NULL DEFAULT '4',
  `createdTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `createdBy` int NOT NULL DEFAULT '1',
  `isDeleted` int NOT NULL DEFAULT '0',
  `passwordHash` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `account` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `updatedTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `updatedBy` int NOT NULL DEFAULT '1',
  `createdByAccount` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `updatedByAccount` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `roleType` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'viewer',
  `roleWeight` int NOT NULL DEFAULT '3',
  `roleName` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '访客',
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_4ab2df0a57a74fdf904e0e2708` (`account`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (1, '牛奶', 1, '2024-09-25 13:53:01.823172', 1, 0, '$2b$10$DwWI/6ziZ2tW3WgvzAanXuiorSOQoTfoQZh7PZFl6U2pxSU2WgEO6', 'niunai@niunai.com', '2024-10-14 16:40:48.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'systemAdmin', 0, '系统管理员');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (3, '唐僧', 2, '2024-09-25 15:05:43.890304', 1, 0, '$2b$10$k0weRepWdzEt8/ICN56njuTU6Fyl6QrLLd.NyzqP/6jaDq4vN3Wva', 'tang@sanzang.com', '2024-10-14 16:40:46.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'admin', 1, '管理员');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (4, '孙悟空', 3, '2024-09-25 15:07:21.989991', 1, 0, '$2b$10$7teFt8S5qd8EUBUvk9OccuwZbb.FcDwze3eE0hKCMmEuWgYTTcbSW', 'sun@wukong.com', '2024-10-14 16:40:43.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'user', 2, '用户');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (5, '女儿国国王', 4, '2024-09-25 15:20:37.709201', 1, 1, '$2b$10$rs.hlXF1Aonnylfr7qETh.a7fzc1gIV4nWGAgMlazrB4IEhQDdRwK', 'nver@guowang.com', '2024-10-15 17:18:18.000000', 3, 'niunai@niunai.com', 'tang@sanzang.com', 'viewer', 3, '访客');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (6, '乌鸡', 4, '2024-09-26 16:39:34.027000', 1, 0, '$2b$10$5DGNgtbyPYS8OC8eHv/8Tuxus8/fPV4TNlH5d0.Ty9w5jIqotiemO', 'wu@ji.com', '2024-10-14 18:23:08.000000', 6, 'niunai@niunai.com', 'wu@ji.com', 'viewer', 3, '访客');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (7, '猪八戒', 3, '2024-09-27 14:03:20.252391', 1, 0, '$2b$10$j19NONi2ROTwW3QDVLuVi.OwU3FbPgHmjpHwJm4NQHS1aB5iONKY.', 'zhu@bajie.com', '2024-10-14 16:40:37.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'user', 2, '用户');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (8, '沙僧', 3, '2024-09-27 14:10:22.560899', 1, 0, '$2b$10$U2MeKShx4Rx/RDFckBOr4uR/D9yqOoOY4ajGNM1POicb27FVTLoKC', 'sha@seng.com', '2024-10-14 16:39:03.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'user', 2, '用户');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (10, '小白龙', 3, '2024-10-09 11:06:52.073391', 1, 1, '$2b$10$5rbQeBMxxEcqPCQEZ5X0felVLaOvxLDtfsRBXWzfFKO0XzXJYKn7C', 'xiao@bailong.com', '2024-10-14 17:19:08.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'user', 2, '用户');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (14, '铁扇公主', 4, '2024-10-09 11:13:26.389254', 1, 1, '$2b$10$cZT.q9nNQwKX8bXv6azDXORL2KSMe.i7fLe6giHUTfwJQjhArxzhi', 'tie@shan.com', '2024-10-14 17:19:08.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'viewer', 3, '访客');
INSERT INTO `user` (`id`, `username`, `roleId`, `createdTime`, `createdBy`, `isDeleted`, `passwordHash`, `account`, `updatedTime`, `updatedBy`, `createdByAccount`, `updatedByAccount`, `roleType`, `roleWeight`, `roleName`) VALUES (15, '王子波', 4, '2024-10-14 17:13:54.799121', 1, 1, '$2b$10$YbeJMRToow0G.UGwlimjX.u4LURcDRWrN.EfILrSY8gDPNiZmhaJK', 'wang@zibo.com', '2024-10-14 17:18:53.000000', 1, 'niunai@niunai.com', 'niunai@niunai.com', 'viewer', 3, '访客');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
